home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 87 / Issue 087 - May 1995 - 0595.iso / ivan / filesfo& / fmpro.exe / TEST.FM (.txt) < prev   
Encoding:
FileMaker Pro Database  |  1995-03-13  |  35.0 KB  |  1,170 lines

  1. 124-90-3042@
  2. 244-90-5242@
  3. 987-78-0985@
  4. Mill@
  5. Rouge@
  6. Shipping@
  7.     LAST NAME
  8. HBAM2001MAY84@
  9.     TEST.FM:*
  10. Benjamin
  11. Billy
  12. Billy
  13. Glenn
  14. Heidi
  15. Janet
  16. Jennifer
  17. Jeremy
  18. Julie
  19. Nancy
  20. Pamela
  21. Roger
  22. Samuel
  23. Sonia
  24. Susan
  25. Akers
  26. Ammond
  27. Corning
  28. Davison
  29. Eison
  30. Forest
  31. Johnson
  32. Kenwood
  33. Licklighter
  34. Michaels
  35. Norris
  36. Peterson
  37. Richley
  38. Smith
  39. Swanson
  40. Waters
  41. Winford
  42. 159-14-2755
  43. 243-14-9876
  44. 13/03/95
  45. DATE OF LAST CHANGE
  46. EMPLOYEE NUMBER
  47. FINALNUM
  48. FIRST NAME
  49. GROUP
  50.     HIRE DATE
  51. HOME PHONE
  52. 06/10/92
  53. DATE OF LAST CHANGE
  54. EMPLOYEE NUMBER
  55. FIRST NAME
  56. GROUP
  57.     HIRE DATE
  58. HOME PHONE
  59. 06/10/92
  60. DATE OF LAST CHANGE
  61. EMPLOYEE NUMBER
  62. FIRST NAME
  63. GROUP
  64.     HIRE DATE
  65. HOME PHONE
  66.     LAST NAME
  67. NEWCODE
  68. NEWNUM
  69. NEXT MONTH SHIFT
  70. NUMBER IN GROUP
  71. NUMBER IN SHIFT
  72. OLDNUM
  73. PICTURE
  74. SHIFT
  75. SOCIAL SECURITY #
  76. STATE
  77. STREET
  78. First NameB
  79. A    Last NameB
  80. Social Security #B
  81. StreetB
  82. CityB
  83. StateB
  84. Home PhoneB
  85. Employee NumberB
  86. EMPLNUMS.FM
  87. \NEWFILES\+
  88. ShiftB
  89. Next Month ShiftB
  90. A    Hire DateB
  91. Date of Last ChangeB
  92. GroupB
  93. PictureB
  94. Number in GroupB
  95. Number in ShiftB
  96. oldnumB
  97. Home Phone
  98. codeB
  99. ["0"&left(NumToText (TextToNum (Middle (Home Phone ,Position (Home Phone , "0" ,1 ),8 ))),3)
  100. 509/555-5487
  101. 513/555-1987
  102. 602/555-5577
  103. 603/555-3322
  104. 606/555-5486
  105. 615/555-8899
  106. 616/555-3698
  107. 702/555-9875
  108. 712/555-5245
  109. 715/555-9987
  110. 719/555-4477
  111. 801/555-4566
  112. 803/555-7911
  113. 814/555-7777
  114. 913/555-323434
  115. First Name
  116. E    Last Name
  117. Social Security #
  118. Street
  119. State
  120. Home Phone
  121. Employee Number
  122. Shift
  123. Next Month Shift
  124. Employee Number
  125. Shift
  126. Next Month Shift
  127. E    Hire Date
  128. Date of Last Change
  129. Group
  130. Picture
  131. oldnum
  132. newcode
  133. newnum
  134. finalnum
  135. ReportB
  136. First Name
  137. First Name
  138. E    Last Name
  139. JulieB
  140. Davison
  141. Apple LaserWriter II NT
  142. LaserWriter II NT
  143. Pro 2.0F!
  144. Pro 2.0I
  145.     UKENG.NDX
  146. \WINDOWS\CLARIS\Ih
  147.     USERD.SPL
  148. \WINDOWS\CLARIS\
  149. JohnsonC
  150. 957-14-0835D
  151. 560 Yorkton Ave.E
  152. ArmonkF
  153. 12345H
  154. (0101) 399 9999
  155. 6822J
  156. 09/03/88M
  157. 13/03/95N    PersonnelR
  158. (0101) 399 9999
  159. 0101T
  160. (0181) 3U
  161. (0181) 33999999V
  162. 0013999999
  163. SoniaB
  164. LongC
  165. 321-16-0755D
  166. 547 Brade St.E
  167. BiloxiF
  168. 12345H
  169. 0344 999999I
  170. 6879J
  171. 21/10/88M
  172. 13/03/95N
  173. ShippingR
  174. 0344 999999S
  175. 0344U
  176. 999999V
  177. 999999
  178. JenniferB
  179. Norris
  180. Norris
  181. NorrisrB
  182. Norris
  183. Marketing
  184. Operations
  185. Personnel
  186. Printing
  187. Publishing
  188. 753-14-1755D
  189. 793 Old Mill RoadE    AllentownF
  190. 12345H
  191. 0800 800 800I
  192. 6842J
  193. 06/04/87M
  194. 01/03/95N
  195. OperationsR
  196. 0800 800 800S
  197. 0800T
  198. (0800)U
  199. (0800)800800V
  200. (0800)800800
  201. BenjaminB
  202. PetersonC
  203. 654-14-1545D
  204. 839 Arlington Ave.E
  205. DaytonF
  206. 54321H
  207. 513/555-1987I
  208. 6805J
  209. 23/01/86M
  210. 01/03/95N
  211. PublishingR
  212. 513/555-1987S
  213. 513/T
  214. code U
  215. 513/555-1987V
  216. 513/555-1987
  217. Glenn
  218. Shipping
  219. 205/555-2388
  220. 208/555-8135
  221. 304/555-9966
  222. 315/555-0011
  223. 318/555-4577
  224. 401/555-3258
  225. 406/555-1144
  226. 407/555-8297
  227. 5-4655
  228. 505/555-8822
  229. 509/555-5487
  230. 513/555-1987
  231. 602/555-5577
  232. 603/555-3322
  233. 606/555-5486
  234. 615/555-8899
  235. 616/555-3698
  236. 702/555-9875
  237. 712/555-5245
  238. 715/555-9987
  239. 719/555-4477
  240. 801/555-4566
  241. 803/555-7911
  242. 814/555-7777
  243. 913/555-3234
  244. AkersC
  245. 977-90-8221D
  246. 614 Harvard Ct.E
  247. Carson CityF
  248. 54321H
  249. 702/555-9875I
  250. 6819J
  251. 15/03/87M
  252. 01/03/95N    MarketingR
  253. 702/555-9875S
  254. 0255T
  255. (01255)U
  256. (01255)59875V
  257. (01255)59875
  258. SamuelB
  259. CorningC
  260. 879-90-3042D
  261. 500 Burmeister RdE
  262. Hilton HeadF
  263. 54321H
  264. 803/555-7911I
  265. 6877J
  266. 08/10/85M
  267. 01/03/95N    MarketingR
  268. 803/555-7911S
  269. 0355T
  270. (01355)U
  271. (01355)57911V
  272. (01355)57911
  273. Darton
  274. Desert
  275. Drive
  276. Fielding
  277. Harvard
  278. Howingser
  279. Island
  280. Lakeview
  281. Liberty
  282. Lockwood
  283. Allentown
  284. Armonk
  285. Biloxi
  286. Carson
  287. Cheylan
  288. Concord
  289. Dayton
  290. Foster
  291. Green
  292. Hilton
  293. Huntsville
  294. Lansing
  295. Pocatello
  296. Santa
  297. 12345
  298. 54321
  299. JohnB
  300. Winford IIIC
  301. 159-14-2755D
  302. 904 Brunswick Ave.E    Green BayF
  303. 54321H
  304. 715/555-9987I
  305. 6856J
  306. 08/06/88M
  307. 01/03/95N    PersonnelR
  308. 715/555-9987S
  309. 715/T
  310. code U
  311. 715/555-9987V
  312. 715/555-9987
  313. Julie B
  314. DavisonC
  315. 544-90-3042D
  316. 35 Ravenwood AvenueE
  317. Foster CityF
  318. 12345H
  319. 408/555-0900I
  320. 6887J
  321. 01/12/88M
  322. 01/03/95N    MarketingR
  323. 408/555-0900S
  324. 0855T
  325. (01855)U
  326. (01855)50900V
  327. (01855)50900
  328. Nancy B
  329. EisonC
  330. 244-90-5242D
  331. 2820 Compton Pl.E
  332. LansingF
  333. 12345H
  334. 616/555-3698I
  335. 6870J
  336. 21/09/85M
  337. 01/03/95N
  338. PublishingR
  339. 616/555-3698S
  340. 616/T
  341. code U
  342. 616/555-3698V
  343. 616/555-3698
  344. Janet B
  345. SwansonC
  346. 465-20-1255D
  347. 814 Harvard Ave.E
  348. ConcordF
  349. 12345H
  350. 408-555-5684I
  351. 6892J
  352. 10/12/87M
  353. 01/03/95N
  354. OperationsR
  355. 408-555-5684S
  356. 0855T
  357. (01855)U
  358. (01855)55684V
  359. (01855)55684
  360. 244-90-5242
  361. 284-34-0755
  362. 284-44-0755
  363. 321-16-0755
  364. 357-19-0755
  365. 465-20-1255
  366. 523-13-0755
  367. 543-90-4442
  368. 544-90-3042
  369. 544-91-7654
  370. 576-14-7319
  371. 578-90-3042
  372. 654-14-1545
  373. 654-17-0755
  374. 667-14-0987
  375. 753-14-1755
  376. 842-18-4545
  377. 852--94-2900
  378. 865-14-0125
  379. 879-90-3042
  380. 956-14-0080
  381. 957-14-0835
  382. 963-11-0755
  383. 977-90-8221
  384. 987-18-0755
  385. 987-64-8555
  386. Avenue
  387. Brade
  388. Brunswick
  389. Burmeister
  390. Compton
  391. Craigmont
  392. Mary JoB
  393. LicklighterC
  394. 667-14-0987D
  395. 233 Turquoise Ct.E
  396. Santa FeF
  397. 12345H
  398. 505/555-8822I
  399. 6853J
  400. 10/06/85M
  401. 01/03/95N
  402. PrintingR
  403. 505/555-8822S
  404. 0555T
  405. (01555)U
  406. (01555)58822V
  407. (01555)58822
  408. SusanB
  409. KenwoodC
  410. 576-14-7319D
  411. 466 West Ave.E
  412. CheylanF
  413. 12345H
  414. 304/555-9966I
  415. 6864J
  416. 07/08/87M
  417. 01/03/95N
  418. PrintingR
  419. 304/555-9966S
  420. 0455T
  421. (01455)U
  422. (01455)59966V
  423. (01455)59966
  424. RichleyC
  425. 987-64-8555D
  426. 911 Portsmouth Ave.E
  427. HuntsvilleF
  428. 12345H
  429. 205/555-2388I
  430. 6849J
  431. 11/05/84M
  432. 01/03/95N
  433. PublishingR
  434. 205/555-2388S
  435. 0555T
  436. (01555)U
  437. (01555)52388V
  438. (01555)52388
  439. PamelaB
  440. 578-90-3042D
  441. 690 Fielding Pl.E
  442. AmesF
  443. 12345H
  444. 712/555-5245I
  445. 6869J
  446. 14/09/86M
  447. 01/03/95N    MarketingR
  448. 712/555-5245S
  449. 712/T
  450. code U
  451. 712/555-5245V
  452. 712/555-52459
  453. 913/555-3234
  454. 914/555-1304
  455. 919/555-0805
  456. 999999
  457. aFfWf
  458. qFfD3
  459. HeidiB
  460. 852--94-2900D
  461. 749 Craigmont Ave.E    PocatelloF
  462. 12345H
  463. 208/555-8135I
  464. 6840J
  465. 16/04/84M
  466. 01/03/95N
  467. PrintingR
  468. 208/555-8135S
  469. 0855T
  470. (01855)U
  471. (01855)58135V
  472. (01855)58135
  473. MeniB
  474. WatersC
  475. 357-19-0755D
  476. 441 Liberty SquareE
  477. Half Moon BayF
  478. 12345H
  479. 408/555-6241I
  480. 6862J
  481. 19/07/87M
  482. 01/03/95N
  483. SalesR
  484. 408/555-6241S
  485. 0855T
  486. (01855)U
  487. (01855)56241V
  488. (01855)56241
  489. DennisB
  490. AmmondC
  491. 543-90-4442D
  492. 438 Needham Dr.E
  493. WichitaF
  494. 54321H
  495. 913/555-3234I
  496. 6816J
  497. 08/08/88M
  498. 01/03/95N    MarketingR
  499. 913/555-3234S
  500. 913/T
  501. code U
  502. 913/555-3234V
  503. 913/555-3234
  504. LukeB
  505. ForestC
  506. 865-14-0125D
  507. 99 Lakeview Ave.E
  508. RedmondF
  509. 54321H
  510. 509/555-5487I
  511. 6845J
  512. 24/05/83M
  513. 01/03/95N
  514. FinanceR
  515. 509/555-5487S
  516. 0955T
  517. (01955)U
  518. (01955)55487V
  519. (01955)55487
  520. Monument
  521. Nashoba
  522. Needham
  523. Newport
  524. North
  525. Turquoise
  526. Yorkton
  527. Allentown
  528. Armonk
  529. Biloxi
  530. Carson
  531. Cheylan
  532. Concord
  533. Dayton
  534. Foster
  535. Green
  536. Hilton
  537. Huntsville
  538. Lansing
  539. Pocatello
  540. Santa
  541. 12345
  542. 54321
  543. Marketing
  544. Operations
  545. Personnel
  546. Printing
  547. Publishing
  548. Sales
  549. Portsmouth
  550. Ravenwood
  551. Richards
  552. Square
  553. Turquoise
  554. Yankee
  555. Allentown
  556. Armonk
  557. Austin
  558. Baton
  559. Biloxi
  560. Butte
  561. Carson
  562. Charlotte
  563. Cheylan
  564. Concord
  565. Dayton
  566. Eugene
  567. Foster
  568. Green
  569. Hilton
  570. Huntsville
  571. Jerome
  572. Lakewood
  573. Lansing
  574. Louisville
  575. Manchester
  576. Memphis
  577. Pocatello
  578. Providence
  579. Provo
  580. Redmond
  581. 12345
  582. 54321
  583. 205/555-2388
  584. 208/555-8135
  585. 304/555-9966
  586. 315/555-0011
  587. 318/555-4577
  588. 401/555-3258
  589. 406/555-1144
  590. 407/555-8297
  591. 408-555-5684
  592. 408/555-0900
  593. 408/555-6241
  594. 503/555-4655
  595. 505/555-8822
  596. -3234
  597. JeremyB
  598. SmithC
  599. 987-78-0985D
  600. 912 Darton Blvd.E
  601. EugeneF
  602. 54321H
  603. 503/555-4655I
  604. 6843J
  605. 23/04/86M
  606. 01/03/95N
  607. PublishingR
  608. 503/555-4655S
  609. 0355T
  610. (01355)U
  611. (01355)54655V
  612. (01355)54655
  613. Roger B
  614. MichaelsC
  615. 243-14-9876D
  616. 786 North Desert Rd.E
  617. JeromeF
  618. 54321H
  619. 602/555-5577I
  620. 6867J
  621. 25/08/84M
  622. 01/03/95N
  623. PrintingR
  624. 602/555-5577S
  625. 0255T
  626. (01255)U
  627. (01255)55577V
  628. (01255)55577
  629. Finance
  630. Marketing
  631. Operations
  632. Personnel
  633. Printing
  634. Publishing
  635. Sales
  636. 987-78-0985
  637. Arlington
  638. Arroyo
  639. Avenue
  640. Battle
  641. Brade
  642. Brunswick
  643. Burmeister
  644. Chardon
  645. Compton
  646. Craigmont
  647. BillyB    AdlingtonC
  648. 544-91-7654D
  649. 613 Main St.E
  650. MemphisF
  651. 54321H
  652. 615/555-8899I
  653. 6801J
  654. 13/01/86M
  655. 01/03/95N    MarketingR
  656. 615/555-8899S
  657. 615/T
  658. code U
  659. 615/555-8899V
  660. 615/555-8899
  661. VernB
  662. CritserC
  663. 144-90-3042D
  664. 700 Battle Rd.E
  665. ManchesterF
  666. 54321H
  667. 603/555-3322I
  668. 6863J
  669. 06/08/81M
  670. 01/03/95N    MarketingR
  671. 603/555-3322S
  672. 0355T
  673. (01355)U
  674. (01355)53322V
  675. (01355)53322
  676. Billy
  677. Danielle
  678. Denise
  679. Dennis
  680. Doris
  681. Glenn
  682. Heidi
  683. Irfon
  684. Janet
  685. Jennifer
  686. Jeremy
  687. Julie
  688. Nancy
  689. Pamela
  690. Richard
  691. Adlington
  692. Akers
  693. Ammond
  694. Corning
  695. Critser
  696. Danon
  697. Davison
  698. Eison
  699. Forest
  700. Johnson
  701. Kenwood
  702. Licklighter
  703. Michaels
  704. Norris
  705. Peterson
  706. Richley
  707. Smith
  708. Swanson
  709. Tisornon
  710. Waters
  711. Winford
  712. TyroneB
  713. DanonC
  714. 124-90-3042D
  715. 802 Nashoba Rd.E
  716. LakewoodF
  717. 54321H
  718. 719/555-4477I
  719. 6884J
  720. 05/11/83M
  721. 01/03/95N    MarketingR
  722. 719/555-4477S
  723. 719/T
  724. code U
  725. 719/555-4477V
  726. 719/555-4477
  727. IrfonB
  728. KohnC
  729. 963-11-0755D
  730. 111 Howingser Ave.E
  731. LouisvilleF
  732. 54321H
  733. 606/555-5486I
  734. 6839J
  735. 27/04/85M
  736. 01/03/95N
  737. ShippingR
  738. 606/555-5486S
  739. 0655T
  740. (01655)U
  741. (01655)55486V
  742. (01655)55486
  743. 124-90-3042
  744. 144-90-3042
  745. 147-12-0755
  746. 159-14-2755
  747. 195-90-3042
  748. 243-14-9876
  749. TisornonC
  750. 147-12-0755D
  751. 798 Park Ave.E
  752. ProvidenceF
  753. 54321H
  754. 401/555-3258I
  755. 6807J
  756. 27/01/82M
  757. 01/03/95N
  758. SalesR
  759. 401/555-3258S
  760. 0155T
  761. code U
  762. code 53258V
  763. code 53258
  764. RichardB
  765. GelhardC
  766. 654-17-0755D
  767. 562 New Chardon Rd.E
  768. Baton RougeF
  769. 54321H
  770. 318/555-4577I
  771. 6878J
  772. 25/10/84M
  773. 01/03/95N    PersonnelR
  774. 318/555-4577S
  775. 318/T
  776. code U
  777. 318/555-4577V
  778. 318/555-4577A
  779. BillB
  780. LorenC
  781. 987-18-0755D
  782. 75 Lockwood DriveE
  783. ProvoF
  784. 54321H
  785. 801/555-4566I
  786. 6859J
  787. 14/07/83M
  788. 01/03/95N
  789. OperationsR
  790. 801/555-4566S
  791. 0155T
  792. code U
  793. code 54566V
  794. code 54566
  795. DeniseB
  796. FarnsworthC
  797. 956-14-0080D
  798. 54 Arroyo Ave.E
  799. AustinF
  800. 12345H
  801. 814/555-7777I
  802. 6809J
  803. 18/02/87M
  804. 01/03/95N
  805. PrintingR
  806. 814/555-7777S
  807. 814/T
  808. code U
  809. 814/555-7777V
  810. 814/555-7777
  811. Richard
  812. Roger
  813. Samuel
  814. Sonia
  815. Susan
  816. Tyrone
  817. Adlington
  818. Akers
  819. Ammond
  820. Corning
  821. Critser
  822. Danon
  823. Davison
  824. Downing
  825. Eison
  826. Farnsworth
  827. Forest
  828. Gelhard
  829. Gerhard
  830. Johnson
  831. Kenwood
  832. Landers
  833. Licklighter
  834. Loren
  835. Michaels
  836. Norris
  837. Osborne
  838. Peterson
  839. Richley
  840. Smith
  841. Swanson
  842. Tisornon
  843. Waters
  844. Wilford
  845. Winford
  846. Rouge
  847. Santa
  848. Stamford
  849. Tampa
  850. Wichita
  851. LandersC
  852. 523-13-0755 D
  853. 31 Richards Ave.E
  854. ButteF
  855. 12345H
  856. 406/555-1144I
  857. 6803J
  858. 02/01/87M
  859. 01/03/95N
  860. PrintingR
  861. 406/555-1144S
  862. 0655T
  863. (01655)U
  864. (01655)51144V
  865. (01655)51144
  866. NancyB
  867. OsborneC
  868. 284-34-0755D
  869. 32 Newport Rd.E    CharlotteF
  870. 12345H
  871. 919/555-0805I
  872. 6872J
  873. 13/09/88M
  874. 01/03/95N
  875. PurchasingR
  876. 919/555-0805S
  877. 919/T
  878. code U
  879. 919/555-0805V
  880. 919/555-0805
  881. Finance
  882. Marketing
  883. Operations
  884. Personnel
  885. Printing
  886. Publishing
  887. Purchasing
  888. Sales
  889. DorisB
  890. GerhardC
  891. 284-44-0755D
  892. 79 Island View Dr.E
  893. TampaF
  894. 12345H
  895. 407/555-8297I
  896. 6810J
  897. 06/02/88M
  898. 01/03/95N    PersonnelR
  899. 407/555-8297S
  900. 0755T
  901. (0755)U
  902. (0755)58297V
  903. (0755)58297
  904. DanielleB
  905. DowningC
  906. 195-90-3042D
  907. 611 Monument Dr.E
  908. StamfordF
  909. 12345H
  910. 914/555-1304I
  911. 6851J
  912. 05/06/88M
  913. 01/03/95N    MarketingR
  914. 914/555-1304S
  915. 914/T
  916. code U
  917. 914/555-1304V
  918. 914/555-1304
  919. Billy
  920. Richard
  921. 124-90-3042@
  922. 244-90-5242@
  923. 987-78-0985@
  924. Mill@
  925. Yorkton@
  926. Rouge@
  927. 509/555-5487@
  928. 913/555-3234Q
  929. Shipping@
  930. 408-555-5684@
  931. 919/555-0805@
  932. 318/555-4577@
  933. 719/555-4477@
  934. 50900@
  935. WilfordC
  936. 842-18-4545D
  937. 3015 Yankee St.E
  938. GenevaF
  939. 54321H
  940. 315/555-0011I
  941. 6808J
  942. 20/01/87M
  943. 01/03/95N
  944. SalesR
  945. 315/555-0011S
  946. 315/T
  947. code U
  948. 315/555-0011V
  949. 315/555-0011
  950. 071 323 9113
  951. 22/02/95M
  952. 01/03/95R
  953. 071 323 9113
  954. 0713T
  955. (0171) 3U
  956. (0171) 3239113V
  957. (0171) 3239113
  958. Yorkton
  959. Allentown
  960. Armonk
  961. Austin
  962. Baton
  963. Biloxi
  964. Butte
  965. Carson
  966. Charlotte
  967. Cheylan
  968. Concord
  969. Dayton
  970. Eugene
  971. Foster
  972. Geneva
  973. Green
  974. Hilton
  975. Huntsville
  976. Jerome
  977. Lakewood
  978. Lansing
  979. Louisville
  980. Manchester
  981. Memphis
  982. Pocatello
  983. Providence
  984. Provo
  985. Redmond
  986. Arial
  987. MS Sans Serif
  988. 999999
  989. 01344
  990. 999999
  991. 919/555-0805
  992. 999999
  993. 01200
  994. 01250
  995. 01350
  996. 01400
  997. 01450
  998. 01550
  999. 01650
  1000. 01750
  1001. 01805
  1002. 01950
  1003. 01969
  1004. newcodeB
  1005. CODES.FM.
  1006. \FMPRO\OK
  1007. code 
  1008. newnumB
  1009. if(position(Home Phone,"0",1)=0 or position(Home Phone,"0",1)>4,Home Phone, newcode&middle(NumToText (TextToNum (Middle (Home Phone ,Position (Home Phone , "0" ,1),length(home phone)))),4,length(home phone))) 
  1010. Apple LaserWriter II NT
  1011. (01344)U
  1012. (01344)999999V
  1013. (01344)999999
  1014. (01969)U
  1015. (01969)24358V
  1016. (01969)24358
  1017. Pro 2.0I
  1018.     UKENG.NDX
  1019. \WINDOWS\CLARIS\Ih
  1020.     LAST NAME
  1021. 01255
  1022. 01355
  1023. 01455
  1024. 01555
  1025. 01655
  1026. 01855
  1027. 01955
  1028. 01255
  1029. 01355
  1030. 01455
  1031. 01555
  1032. 01655
  1033. 01855
  1034. 01955
  1035. 315/555-0011
  1036. 55-0011
  1037. 55-0011
  1038. 55-0011
  1039. 55-0011
  1040. 55-0011
  1041. 55-0011
  1042. 55-0011
  1043. 55-0011
  1044. 712/555-5245
  1045. 715/555-9987
  1046. 408-555-5684
  1047. 408/555-0900
  1048. 408/555-6241
  1049. 503/555-4655
  1050. 505/555-8822
  1051. 509/555-5487
  1052. 513/555-1987
  1053. 602/555-5577
  1054. 603/555-3322
  1055. 606/555-5486
  1056. 615/555-8899
  1057. 616/555-3698
  1058. 702/555-9875
  1059. 712/555-5245
  1060. 715/555-9987
  1061. 719/555-4477
  1062. 801/555-4566
  1063. 803/555-7911
  1064. 814/555-7777
  1065. 913/555-3234
  1066. 914/555-1304
  1067. First NameB
  1068. A    Last NameB
  1069. Social Security #B
  1070. StreetB
  1071. CityB
  1072. StateB
  1073. Home PhoneB
  1074. if ((position(home phone,"0",1)>4 or position(home phone,"0",1)=0) ,left(Home Phone,4),"0"&left(NumToText (TextToNum (Middle (Home Phone ,Position (Home Phone , "0" ,1 ),8 ))),3))
  1075. 719/555-4477
  1076. 800800
  1077. 814/555-7777
  1078. 913/555-3234
  1079. 914/555-1304
  1080. 919/555-0805
  1081. 999999
  1082. 0013999999
  1083. 01255
  1084. 01355
  1085. 01455
  1086. 01555
  1087. 01655
  1088. 01855
  1089. 01955
  1090. 315/555-0011
  1091. 318/555-4577
  1092. 3239113
  1093. 55577
  1094. 55684
  1095. 56241
  1096. 57911
  1097. 58135
  1098. 58822
  1099. 59875
  1100. 59966
  1101. 615/555-8899
  1102. 616/555-3698
  1103. 712/555-5245
  1104. 715/555-9987
  1105. 719/555-4477
  1106. 800800
  1107. 913/555-3234
  1108. finalnumB
  1109. if(left(code,3)<>"010",newnum,"00"&middle(NumToText (TextToNum (Middle (Home Phone ,Position (Home Phone , "0" ,1),length(home phone)))),3,length(home phone))) 
  1110. 010    &
  1111. A    Layout #1
  1112. Report
  1113. A    Layout #1B
  1114. 318/555-4577
  1115. 3239113
  1116. 33999999
  1117. 50900
  1118. 51144
  1119. 513/555-1987
  1120. 52388
  1121. 53258
  1122. 53322
  1123. 54566
  1124. 54655
  1125. 55486
  1126. 55487
  1127. 55577
  1128. 55684
  1129. 56241
  1130. 57911
  1131. 58135
  1132. 58297
  1133. 58822
  1134. 59875
  1135. 59966
  1136. 615/555-8899
  1137. 616/555-3698
  1138. 712/555-5245
  1139. 715/555-9987
  1140. 50900
  1141. 51144
  1142. 513/555-1987
  1143. 52388
  1144. 53258
  1145. 53322
  1146. 54566
  1147. 54655
  1148. 55486
  1149. 55487
  1150. 55577
  1151. 55684
  1152. 56241
  1153. 57911
  1154. 58135
  1155. 58297
  1156. 58822
  1157. 59875
  1158. 59966
  1159. 615/555-8899
  1160. 616/555-3698
  1161. 712/555-5245
  1162. 715/555-9987
  1163. 719/555-4477
  1164. 800800
  1165. 814/555-7777
  1166. 913/555-3234
  1167. 914/555-1304
  1168. 919/555-0805
  1169. 999999
  1170.